﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace WaveMaster.Holidays.Club.Domain
{
    public class Passport
    {
        public long m_passportID;
        public string m_passportNo;
        public DateTime m_issueDate;
        public DateTime m_expireDate;
        public string m_country;
        public string m_officeIssue;
        public string m_name;
        public string m_gender;
        public string m_birthPlace;
        public DateTime m_birthDate;
        public string m_nationality;
        public string m_placeOfResidence;
        public string m_occupation;
        public string m_maritalStatus;
        public string m_address;
        public string m_city;
        public string m_zipcode;
        public string m_remark;
        public string m_idnumber;
        public DateTime m_cretnDate;
        public DateTime m_modfctnDate;
        public long m_cretnBy;
        public long m_modfctnBy;

        public Passport(long id)
        {
            m_passportID = id;
        }
        public Passport()
        {
        }
        public Passport(string passportNo)
        {
            m_passportNo = passportNo;
        }
        public Passport(MySqlDataReader rd)
        {
            m_passportID = Convert.ToInt64(rd["m_passportID"]);
            m_passportNo = rd["m_passportNo"].ToString();
            m_issueDate = Convert.ToDateTime(rd["m_issueDate"]);
            m_expireDate = Convert.ToDateTime(rd["m_expireDate"]);
            m_country = rd["m_country"].ToString();
            m_officeIssue = rd["m_officeIssue"].ToString();
            m_name = rd["m_name"].ToString();
            m_gender = rd["m_gender"].ToString();
            m_birthPlace = rd["m_birthPlace"].ToString();
            m_birthDate = Convert.ToDateTime(rd["m_birthDate"]);
            m_nationality = rd["m_nationality"].ToString();
            m_placeOfResidence = rd["m_placeOfResidence"].ToString();
            m_occupation = rd["m_occupation"].ToString();
            m_maritalStatus = rd["m_maritalStatus"].ToString();
            m_address = rd["m_address"].ToString();
            m_city = rd["m_city"].ToString();
            m_zipcode = rd["m_zipcode"].ToString();
            m_remark = rd["m_remark"].ToString();
            m_idnumber = rd["m_idnumber"].ToString();
            m_cretnDate = Convert.ToDateTime(rd["m_cretnDate"]);
            m_cretnBy = Convert.ToInt64(rd["m_cretnBy"]);
            m_modfctnDate = Convert.ToDateTime(rd["m_modfctnDate"]);
            m_modfctnBy = Convert.ToInt64(rd["m_modfctnBy"]);
        }



    }
}
